<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="az137232">CREATE TEXT SEARCH DICTIONARY</title><body><p id="sql_command_desc">Defines a new text search dictionary.</p><section id="section2"><title>Synopsis</title></section>
    <codeblock id="sql_command_synopsis">CREATE TEXT SEARCH DICTIONARY <varname>name</varname> (
    TEMPLATE = <varname>template</varname>
    [, <varname>option</varname> = <varname>value</varname> [, ... ]]
)</codeblock><section id="section3"><title>Description</title>
      <p><varname>CREATE TEXT SEARCH DICTIONARY</varname> creates a new text search dictionary. A
        text search dictionary specifies a way of recognizing interesting or uninteresting words for
        searching. A dictionary depends on a text search template, which specifies the functions
        that actually perform the work. Typically the dictionary provides some options that control
        the detailed behavior of the template's functions.</p>
      <p>If a schema name is given then the text search dictionary is created in the specified
        schema. Otherwise it is created in the current schema.</p>
      <p>The user who defines a text search dictionary becomes its owner.</p>
      <p>Refer to <xref href="../../admin_guide/textsearch/full-text-search.html#full-text-search" format="html" scope="external">Using Full Text Search</xref>
        for further information.</p></section><section id="section4"><title>Parameters</title>
      <parml>
        <plentry>
          <pt><codeph><varname>name</varname></codeph></pt>
          <pd>The name of the text search dictionary to be created. The name can be
            schema-qualified.</pd>
        </plentry>
        <plentry>
          <pt><codeph><varname>template</varname></codeph></pt>
          <pd>The name of the text search template that will define the basic behavior of this
            dictionary.</pd>
        </plentry>
        <plentry>
          <pt><codeph><varname>option</varname></codeph></pt>
          <pd>The name of a template-specific option to be set for this dictionary.</pd>
        </plentry>
        <plentry>
          <pt><codeph><varname>value</varname></codeph></pt>
          <pd>The value to use for a template-specific option. If the value is not a simple
            identifier or number, it must be quoted (but you can always quote it, if you wish).</pd>
        </plentry>
      </parml>
      <p>The options can appear in any order.</p>
            
</section><section id="section5">
      <title>Examples</title>
      <p>The following example command creates a Snowball-based dictionary with a nonstandard list
        of stop words.</p>
      <pre>CREATE TEXT SEARCH DICTIONARY my_russian (
    template = snowball,
    language = russian,
    stopwords = myrussian
);</pre>
    </section><section
          id="section6"><title>Compatibility</title><p>There is no <codeph>CREATE TEXT SEARCH
            DICTIONARY</codeph> statement in the SQL standard.</p></section><section
              id="section7"><title>See Also</title><p><codeph><xref href="ALTER_TEXT_SEARCH_DICTIONARY.xml#topic1" type="topic" format="dita"
          /></codeph>, <codeph><xref href="./DROP_TEXT_SEARCH_DICTIONARY.xml#topic1" type="topic"
            format="dita"/></codeph></p></section></body></topic>
